
create external table if not exists jms_ods.YL_NWM_AREA_WEIGHT
(
    ID                          bigint,
    PROXY_CODE                  string,
    PROXY_NAME                  string,
    TOP_AREA_INFO_CODE          string,
    TOP_AREA_INFO_NAME          string,
    AREA_INFO_CODE              string,
    AREA_INFO_NAME              string,
    CREATE_BY                   bigint,
    UPDATE_BY                   bigint,
    CREATE_BY_NAME              string,
    UPDATE_BY_NAME              string,
    BUSINESS_FINISH_WEIGHT      bigint      default null,
    BUSINESS_FINISH_GUARANTEE   decimal(20, 10) default null,
    BUSINESS_FINISH_TARGET      decimal(20, 10) default null,
    TIMELY_COLLECT_R_WEIGHT     bigint      default null,
    TIMELY_COLLECT_R_GUARANTEE  decimal(20, 10) default null,
    TIMELY_COLLECT_R_TARGET     decimal(20, 10) default null,
    TIMELY_DELIVERY_R_WEIGHT    bigint      default null,
    TIMELY_DELIVERY_R_GUARANTEE decimal(20, 10) default null,
    TIMELY_DELIVERY_R_TARGET    decimal(20, 10) default null,
    TIMELY_SIGN_R_WEIGHT        bigint      default null,
    TIMELY_SIGN_R_GUARANTEE     decimal(20, 10) default null,
    TIMELY_SIGN_R_TARGET        decimal(20, 10) default null,
    TIME_TO_REFUND_R_WEIGHT     bigint      default null,
    TIME_TO_REFUND_R_GUARANTEE  decimal(20, 10) default null,
    TIME_TO_REFUND_R_TARGET     decimal(20, 10) default null,
    LOSS_RATE_WEIGHT            bigint      default null,
    LOSS_RATE_GUARANTEE         decimal(20, 10) default null,
    LOSS_RATE_TARGET            decimal(20, 10) default null,
    DAMAGE_RATE_WEIGHT          bigint      default null,
    DAMAGE_RATE_GUARANTEE       decimal(20, 10) default null,
    DAMAGE_RATE_TARGET          decimal(20, 10) default null,
    CUSTOMER_CR_WEIGHT          bigint      default null,
    CUSTOMER_CR_GUARANTEE       decimal(20, 10) default null,
    CUSTOMER_CR_TARGET          decimal(20, 10) default null,
    FALSE_RECEIPT_WEIGHT        bigint      default null,
    FALSE_RECEIPT_GUARANTEE     decimal(20, 10) default null,
    FALSE_RECEIPT_TARGET        decimal(20, 10) default null,
    WEIGHT10                    bigint      default null,
    GUARANTEE10                 decimal(20, 10) default null,
    TARGET10                    decimal(20, 10) default null,
    WEIGHT11                    bigint      default null,
    GUARANTEE11                 decimal(20, 10) default null,
    TARGET11                    decimal(20, 10) default null,
    WEIGHT12                    bigint      default null,
    GUARANTEE12                 decimal(20, 10) default null,
    TARGET12                    decimal(20, 10) default null,
    WEIGHT13                    bigint      default null,
    GUARANTEE13                 decimal(20, 10) default null,
    TARGET13                    decimal(20, 10) default null,
    WEIGHT14                    bigint      default null,
    GUARANTEE14                 decimal(20, 10) default null,
    TARGET14                    decimal(20, 10) default null,
    WEIGHT15                    bigint      default null,
    GUARANTEE15                 decimal(20, 10) default null,
    TARGET15                    decimal(20, 10) default null,
    CREATE_TIME                 date,
    UPDATE_TIME                 date,
    START_DATE                  date,
    END_DATE                    DATE,
    CREATE_CODE                 string,
    UPDATE_CODE                 string
)comment '区域权重配置'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/yl_nwm_area_weight'
tblproperties (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);
